Topics
Started by
Posts
Last post
Hi Having recently set up a Data Warehouse at work, we have been asked to come up with a solution …
5 replies
I need to create sql statement wherein if I feed the following table fields as input parameters: Ch…
2 replies
I am running MSSQL 2000 sp4. Can someone please tell me how I can get the value of "count(*) AS lin…
22 replies
CREATE PROCEDURE TestSproc2 @size int = 20, @current int , @columns varchar(1000) = '*', @t…
6 replies
I use the following code to find references to variables. SET @StringToSearch = 'drop table' SET …
19 replies
I have a field named earlyLate in table time which has to be updated with earlytime and latetime wh…
3 replies
Hello Members, This is my first post on sqlteam forum. I have been working as BI developer using Cr…
8 replies
Hi all. Studying for 70-433 exam. Book states (in the where clause explanation: "For indexes to b…
3 replies
Hi I have a query that i need to produce that looks at codes and their positions. This is the my …
13 replies
i have a table in which i have records like Table P ProblemID Desc 1 this is a test 1 …
4 replies
Hi Have to buy a copy of SQL Server for an in house application. Feature wise workgroup edition eit…
2 replies
Hi all, I have an SSIS package that feeds a Contact table in my database. This contains normal for…
7 replies
Given your experience, and based on the following scenario, which of the following restore solution…
3 replies
WITH CTE( ProblemID,Who , seq ) AS ( SELECT .problemId, X.Who, ROW_NUMBER() OVER (…
2 replies
Hi all, So we have a 2005 box that runs are email archive system. All system dbs and user dbs are …
2 replies
Viewing 15 topics - 3,841 through 3,855 (of 5,050 total)
You must be logged in to create new topics.