|
You're welcome.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hey,
So I am trying to get the Highest MenuOrder Value there is increment that by one and then use that value to insert a new object in with the next highest menu order
My attempt so far is as so:
Declare @MenuSeed as int
Select @MenuSeed = Top(1) MenuOrder
From Pages
Order By MenuOrder DESC
And of course that doesn't work, but I am kinda lost on what to do here, can anyone shed some light?
Thanks Alot
-Seth
|
|
|
|
|
Declare @MenuSeed as int<br />
<br />
Set @MenuSeed = (select max(MenuOrder) From PagesOrder)
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
SET @MenuSeed = (Select Top 1 MenuOrder From Pages Order By MenuOrder DESC )
OR
Select Top 1 @MenuSeed = MenuOrder From Pages Order By MenuOrder DESC
Please... SAVE my time by rating the posts that you read!
There are 10 kinds of people in the world: those who understand binary and those who don't.
|
|
|
|
|
While importing data from a text file using the wizard i get the error
Invalid character value for cast specification
There's a bad record in the file... but the file is huge so it's nearly impossible to find it by hand. Is there a way to import the data and ignore records that are malformed or the data isn't in the data type it should be?
TIA
|
|
|
|
|
With SQL Server SSIS add a data transformation task and add a datasource (where the bad data is) and a destination (scrubbed data). drag green arrow from source to destination.
Add a second destination and set on failure of first destination to redirect to second (red arrow). You can use a flat file if you want.
|
|
|
|
|
I NEVER use transforms in the ETL layer. I load the data in a table using large varchar fields and use a procedure to do the transforms. This maybe (is) old fashioned but I find I have much better control over the data using a procedure. I can manage the exceptions more to my liking and the bloody thing doesn't break in the middle of the load.
One reason I dislike SSIS and hate Biztalk is the complexity they instill into a basically simple operation.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
One of our clients have recently had one of their two servers changed. The server that got changed contained Active Directory with all the permissions for all users. The other server has MS SQL Server 2005 installed.
Since the server change, users cannot use the Management Studio from their client machines to log on to SQL Server using Windows Authentication. I'm presuming that this is because since the server change, there is some sort of security ID which has changed meaning that the SQL Server doesn't recognise it even though ther name of the new server is the same and the name of the domain is still the same.
My question is this, what can I do about this??
Thanks in advance for any help.
|
|
|
|
|
Look at the system, security and application logs on SQL Server. Look for security failures and dns errors. yell at the admins.
rinse and repeat..
|
|
|
|
|
Have been doing some research and it seems that I need to update the SIDs in the master database for each login to match those of the newly created users in Active Directory.
If anyone knows of a way to do this then it would be appreciated. Thanks.
|
|
|
|
|
Hi,
Sounds like some or all your logins have orphaned. Check if this is true with sp_validatelogins
Mika
|
|
|
|
|
hi,
I don´t know if i can perform this in sql.
I trigger one particular store_procedure, (for exemple select * from tablename), but i want to focus a particular row, or make the scroll center that row.
Well i think i have to write a procedure with a parameter (id).
But how can a perform this?! if possible 
nelsonpaixao@yahoo.com.br
|
|
|
|
|
nelsonpaixao wrote: i want to focus a particular row, or make the scroll center that row
Data presentation detail like that is not what the database engine does. You are asking about something that happens, or should be happening, in the presentation layer.
|
|
|
|
|
IS batch_control an automatic table in SQL Server database? can anyone tell me where I can find the knowledge about it? Thanks very much.....
|
|
|
|
|
Hi,
doesn't sound like SQL Server's own table to me. In what database this table resides and under what schema?
Mika
|
|
|
|
|
I saw that included in some stored procedures in my company's DB, is that user-defined table or something else? cause I tried to search for that information online, couldn't get either...
|
|
|
|
|
I would guess that it's user defined. Especially if it resides in user database and not under system schemas, it's defenitely user defined (or by an application other that sql server).
Mika
|
|
|
|
|
if it is a temporary table defined by a user, normally how a user can define that in his/her DB, can you give me more information about that? thanks very much
|
|
|
|
|
Temporary tables have always a special prefix so I don't believe that they are temporary tables for following reasons:
- local temporary tables have a prefix # (table name in procedure would be #batch_control)
- global temporary table have a prefix ## (table name in procedure would be ##batch_control)
Mika
|
|
|
|
|
From query analyzer type
sp_help batch_control this will give you information regarding the columns and indexes which may help you understand better what this table does.
Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
|
|
|
|
|
Using Microsoft SQL 2005 Express I need to be able to prevent the same stored procedure from running more than once at the same time so that if the stored procedure is in progress it does not run again.
Although nothing will break if this occurs the second run will be redundant. I would like to ensure that any unnecessary work performed by the SQL Server is prevented. The Stored Procedure in question performs some housekeeping functionality that has a non-deterministic duration.
I would like to do this all within SQL 2005 Express.
Any help is appreciated. Thank you in advance for your time.
Ant.
I'm hard, yet soft.
I'm coloured, yet clear.
I'm fruity and sweet.
I'm jelly, what am I? Muse on it further, I shall return!
- David Walliams (Little Britain)
|
|
|
|
|
Hi,
You could use locking for this. Create a small table and insert a single row in it. In the beginning of the procedure, update the row in the table to acquire lock and in the end of the procedure commit your changes. For example:
CREATE TABLE ProcedureRun (LastRun datetime);
INSERT INTO ProcedureRun (LastRun) VALUES (NULL);
CREATE PROCEDURE SomeProcedure AS
BEGIN
UPDATE ProcedureRun SET LastRun = GETDATE();
... do some stuff...
COMMIT;
END;
Hope this helps,
Mika
|
|
|
|
|
Thank you Mika, I have decided to take your advise. The concept of creating a "control table" seems a good one.
Ant.
I'm hard, yet soft.
I'm coloured, yet clear.
I'm fruity and sweet.
I'm jelly, what am I? Muse on it further, I shall return!
- David Walliams (Little Britain)
|
|
|
|
|
You're welcome 
Mika
|
|
|
|
|
hi all,
To extract SQLSERVER.exe, we run SQLEXPR /X from the command line which prompt the user to specify the Loaction where he want to extract the files.but i want to extract this file programmatically. so how can perform this task in vb.net ? I know shell command but i want to skip the Step, in which it asks from user for location of the extract files.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
