Topics
Started by
Posts
Last post
I have a complex store procedure and I need print of output from store procedure that's why i am de…
6 replies
Hi all, In my SQL Server Management Studio Express, I executed the following code: --scPivot1.sql--…
1 replies
I have a table product with a field productid. First,I have to calulate the count(productid). Next,…
2 replies
I have the following code: DECLARE@ConsultantIDnVarChar(50) ,@PeriodDateDateTime ,@Achiev…
6 replies
Here's what I have that creates the temporary table; REATE TABLE ##Acct_Cursor ( TabNam VARCHAR(60…
24 replies
I recieved an odd question from one of the developers today. He wants to create a table with only o…
10 replies
I am trying to use bcp to write a select statement to extract data from one database/server to get …
5 replies
can sql server do this ? table 1 that check table 2 and adding missing dates this my employee tab…
6 replies
I need to write a stored procedure that will substitute a a null date field with a default date wit…
2 replies
Is it possible in SQL Server 2005, to add a column in middle of the table or as first column throug…
8 replies
I have a query that will return one record as its results if you provide two variables: @login and…
2 replies
I have the following code: SET @ConsultantID = '0017860' SET @PeriodDate = '12/01/2007' SET @Achiev…
3 replies
I would like to query for 5 new records everyday. For example, the records at 4am in the morning. …
5 replies
Hello, I am trying to create an xml from a table with tags for each field in the table. Basically i…
7 replies
how to how to combine 2 tables but like this table 1 table Employee on work -----------------------…
8 replies
Viewing 15 topics - 11,056 through 11,070 (of 12,230 total)
You must be logged in to create new topics.