Topics
Started by
Posts
Last post
Hi, I'm new to XML EXPLICIT. I need a parent tag around the second SELECT. I added a simple example…
1 replies
hello , i have a job which start every one minute , i want to before my job start verify with t sq…
1 replies
Hi All, Thanks in advance for those who will contribute. I have a recordset of the following Plan…
10 replies
HI, DECLARE @ID INT SET @ID = NULL DECLARE @TABLE TABLE(fldID INT) INSERT INTO @TABLE SELECT 1 UNIO…
9 replies
Hi I have a table showing data inside brackets, I want to remove the brakets and just keep the data…
3 replies
I have a MS NAV database where company data for each company has separate tables in a single databa…
6 replies
Hi, I have a result set that identifies the employee info in each row...like this: StartDocument PE…
14 replies
Doing crosstabulation with the PIVOT operator would be very helpful for me, but this simple query…
2 replies
I have a table with only two fields (columns). strInitials - nvarchar(3) Emp_No - int - Primary Key…
7 replies
[font="Arial"]Hello All, There may be millions of way calculating age to get years,months,days,H…
7 replies
I need to update an item table(item_tbl1 ) but only if the item number is in item_tbl2 and not alre…
7 replies
Why does the usage of a CTE give these errors ? Msg 156, Level 15, State 1, Line 3 Incorrect syntax…
12 replies
/*This updates the on call operator*/DECLARE @onCall varchar(20), @offCall varchar(20),@onCallPage…
2 replies
It sounds like a simple error with an obvious fix but its not. The sql that caused the error 'Unclo…
1 replies
Dear SQLCentral.com members and administrators, Hello guys, a greeting of peace. It is my first tim…
25 replies
Viewing 15 topics - 1,216 through 1,230 (of 12,234 total)
You must be logged in to create new topics.