you have to declare and assign the variables for TSQL:

if this is all in TSQL, you might use a cursor like this:

--#################################################################################################

--Linked server Syntax for SQL Server With Alias

--#################################################################################################

declare

@svname Nvarchar(64)

declare...

well, i would tackle it with a table defining the hours associated to a givin shift period:

/*--results

RightNow ...

SQL will use all available cores unless you tell it not to; you can select it by right clicking the server>>Properties as seen below; my machine is a single proc...

every application I've ever seen always had the components of the connection string configurable...whether it's part of the GUI, or an ini/config file, the connection strings going to be configurable...they...

I believe the client queries port 1434 and the "SQL Server Browser Service" on the server tells the client which actual port to connect to; it does't try 1433 and...

hey neat;

what you've done is create an "orphaned" user;

inside the sys tables, a unique SID is assifned to every login or user; you may have encountered this when restoring a...

no you can't...all sys.* items are read only views; MS wanted to remove the ability to update meta data tables directly, because too many times an unintended consequence resulted in...

instead of selecting from that table TBL_CYCLE_PARTS,

you instead have to select from some sort of calendar table, with all possible times, and join THAT to your TBL_CYCLE_PARTS;

this will work *i...

altering a table...adding/removing columns,creating or altering procs views, etc etc requires ddl_admin permissions.

in this specific example, i cannot get it to raise the error, but I've encountered other situations where i must issue the GO command after an ALTER TABLE command before...

your example's messing you up... a row of data is just that: each element is related to the others. grabbing a value from another row? why?

if you substitute names for...

At one place I interviewed at, I had a good preliminary interview with a couple of people, one a manager, and the other an HR-type, but it was all high...

a quick google lead me to this solution posted from Dalton from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70901

declare @myString varchar(255)

select @myString = 'BarCode 1'

-- Define the string of characters that we'll need to pull the...

I'm in the same camp of not worrying about the trace impact after this article about the near-zero impact of a server side trace where someone actually compared the...

the integer division, 5,2 is evaluated before the round occurs.

if you divide two integers in SQL, the result is returned in the same datatype...an integer.

That behavior is kind of unique...