Topics
Started by
Posts
Last post
Hi, I'm trying to figure a set-based way to do the following... I have a table: TableA ColA ColB…
7 replies
I have a index maintenance SP that I would like to create in all user databases. I've tried using …
8 replies
By: Ayman
Table : EmpProject Emp Project John CCT1 Lee CDT2 Ra…
4 replies
By: Takauma
I am trying something like code below... I am getting @TableName from a separate table and need to …
2 replies
By: Joe Toon
HI ALL, I have to update a row in the table where there might be possible for duplication. &…
3 replies
Schema Definitions CREATE TABLE #tmpMappings ( Ma…
3 replies
I have a folder which consists of set of .sql files which may be a procedure,table script or any sq…
2 replies
Hi, anybody got anyideas about how to pull only even rows from a table into a dynamic cursor ?
4 replies
This is probably really simple, but it's giving me a tough time. I have to date fields. StartDate a…
1 replies
By: cantor
Hi Guys How do i join year and month column to get a date in a formay 'yyyy/mm' I have got two colu…
4 replies
By: Nuts
Hello, Ive been using DATEADD on GetDate() so I can bring back a date 10 days after today. Is there…
2 replies
Thanks guys but manged to get it sorted
2 replies
I concantenate several columns and would like to do a line feed only if the column value is not nul…
2 replies
By: smknox
Some sql server procedures return information like select query ( i.e some replication procedure s…
4 replies
By: noeld
How can I use a calculated column in the Where clause of that same Select statement. Example: …
3 replies
Viewing 15 topics - 11,611 through 11,625 (of 12,234 total)
You must be logged in to create new topics.