Topics
Started by
Posts
Last post
I have a stored procedure that uses a "Where InvoiceID in (16,17,18)" construct. If I define the in…
3 replies
Hi, I am new to TSQL and I am having a hard time figuring this out: I need to find all duplicates i…
27 replies
Hi, I am working on attendance system. Students when starts school year we mark as 'S'. that is fir…
2 replies
Hi every body! I am new SQL. I can write some amount of queries. I have this problem and I am looki…
10 replies
We have a need to write a proc to take a local file, rename it and move it to another location on t…
7 replies
Hi PPl, In my scenario, I need to alter a table and add a new column to it. This column will be an …
4 replies
Hi All Assume I have a organisation chart table as followed IF (OBJECT_ID ('dbo.SampleOrg', 'U') I…
8 replies
I have a denormalised table with each record representing a projectID. In our projects we have stak…
4 replies
What is the equivalent of nvl2 in tsql? Plus the data types are different depending on the column (…
1 replies
Hey all, I have been trying all day and for the life of me I cannot figure this out, I think my min…
1 replies
here is my cursor for getting rows into a temp table ... but the problem here is as i have my @sc v…
20 replies
Looking for techniques people use for pivoting data. I have done pivoting various ways in the past…
1 replies
Hi, Here is my scenario: I have a table which stores a connection string "Data Source=servername;In…
3 replies
Any ideas on how to parse one column into 4 columns where the on column has a sting value like: \ A…
4 replies
Hi i have a table with column name codes: i have the records as abd,def,ghi---record 1 …
1 replies
Viewing 15 topics - 9,046 through 9,060 (of 12,234 total)
You must be logged in to create new topics.