Topics
Started by
Posts
Last post
i have a table partition on the primary key. It creates daily partitions. How do i delete partition…
1 replies
Hello. I'm trying to insert registers in a table (sql server 2005 in w2003Server). The registers ar…
5 replies
TABLE NAME : UNPIVOT IN THE SOURCE UNPIVOT TABLE DATA IS PRESENT LIKE THIS COLUMN1 | COLUMN2 | CO…
1 replies
Please help! Here is a table with simple values create table #LAYOUT ( id int identity primary key…
5 replies
Hi, I have a table in the database which is 'GSK_ReEnrolment' and I am trying to insert in my table…
7 replies
I'd like to pass a varchar parameter, and in my where clause, i am looking for values in this comma…
8 replies
Do I have to break this query into two different queries? It works perfectly fine when i break it a…
4 replies
Hi guys, I need to implement a multi-parented tree (or digraph) onto SQL Server 2005. I've read sev…
12 replies
Hi there, I am trying to write a recursive function that will pull out a bill bill of materials. Th…
6 replies
Right, new question. I have a varchar(1000) field with some info I need to extract from. I use CHAR…
4 replies
Hi, Can I refer to a new column name in a SELECT statement? Consider this: SELECT (firstname + ' ' …
6 replies
Folks, I've been racking my brains to find a solution to this. Here, Saturdays are counted as work…
13 replies
I am running the following sql statement and when i substitute "sap" or "abap" for "c" or "c#" i do…
2 replies
I've two databases that contain data I'dd like to combine. In Query 1 I've select information about…
6 replies
Hi I have data which is like 'o_corner', I have used the below query but all the records which st…
5 replies
Viewing 15 topics - 6,586 through 6,600 (of 12,234 total)
You must be logged in to create new topics.