Topics
Started by
Posts
Last post
Does anyone know what is CDE in SQL? I have been asked this question on the interview but i had nev…
6 replies
When creating a new record I am getting Insert Failed when insert trigger has xp_cmdshell in it.
3 replies
Hi, I'm having trouble with the pivot statement below and would like to line up each [Comment] valu…
2 replies
Hi All Thanks in advance for any solutions I have been doing some searching and found pattern match…
8 replies
Why is it that "left(null,8) <> 'anything' " is not true with ansi_nulls set to off?I'm tryin…
4 replies
Using the simplest SELECT INTO syntax, the IDENTITY property of a column is part of the definition …
12 replies
below is the temporary table for class assessments. this table contain list of class assessment whi…
3 replies
How to select random (10 or 20) records from table?
24 replies
Hello guys, I currently have a query comprising of joins across multiple tables to process data for…
14 replies
I was wondering if there was a way to do this without dynamic sql? DECLARE @BookSales TABLE(BookTyp…
2 replies
declare @tmp as varchar(25)set @tmp ='ΠΑΠΑΓΟΥ'SELECT *INTO #tmpSortedBooksFROM OPENROWSET(&nbs…
2 replies
Hi Team, I have an issue in information link sql query which joins multiple tables where some dynam…
1 replies
hello to everyone,i use the following code to list a filenames in a temporary table.the code runs w…
4 replies
I have two fields in a SQL Server 2008 view. ID and SubID. There are up to 24 subIDs for any ID. In…
19 replies
Sometimes I don't quite have the right words to google or ask for help with …. please bear with.&nb…
13 replies
Viewing 15 topics - 151 through 165 (of 10,647 total)
You must be logged in to create new topics.