Topics
Started by
Posts
Last post
I need a query to parse and split the string into columns. Declare @ string varchar(8000) Set @Stri…
1 replies
Hello All, I am assigned to create a data dictionary for the database. Does anyone has the template…
1 replies
Hello All, I have a requirement like this. I have 15 columns. I need to get my result set like this…
12 replies
I just altered my table as follows: ALTER TABLE dbo.EpisodePackage ADD WebTagBroadViewId va…
11 replies
I want to execute a bunch of commands (built from values in a table) using xp_cmdshell. However, it…
1 replies
Hi there - I currently have the following select SELECT TM.DESCRION AS Team, CASE TMM.MBR_SEQ_NU…
8 replies
Is there a way in SQL Server to find when was the last date any one accessed the any object in the …
6 replies
Executing below query gives 10 records with NULL values. DECLARE @Pet Table ( PetID INT , PetNam…
6 replies
Hi all - Im needing to tap into some of you TSQL gurus. This is for a trigger that will audit dml o…
1 replies
I have a query where I need to return every 10th row of a particular group upto a certian amount wh…
6 replies
hello , how subtotal from pivot table my scrip ; select [HESAP KODU],[HESAP ADI],ISNULL(Ocak,0) as …
1 replies
Hi everyone, We are using SQLCMD to run our conversion scripts. We faced a problem with one convers…
14 replies
I am using the function ISDATE against column of type varchar which is a date in UK date format (dd…
6 replies
I have a SS2000 database that we want to bring over to SS2008, however, there is pressure to keep t…
5 replies
I am planning for MS SQL Server certification.. I am thinking about 'Exam 70-433: TS: Microsoft SQL…
11 replies
Viewing 15 topics - 6,991 through 7,005 (of 10,635 total)
You must be logged in to create new topics.