Topics
Started by
Posts
Last post
Hi all, I have a formula that works fine in Excel but not in SQL. Hopefully someone knows of some …
9 replies
Hi all, I am relatively new to SQL Server. I have seen that at the end of various statement we give…
6 replies
I want to insert data into a temp table from a talbe... I used this query but getting an error Msg …
1 replies
How can I change the collation for all columns of a table? ________________________________________…
8 replies
hi guys, Still trying to get my head around Xquery I have the following logic SET @CRM = ( SELEC…
1 replies
Hi, I have table which have number of columns one of these columns contains value say 'ABC' I have …
1 replies
Hi, I'm trying to get all the duplicate FKs on the database. I have the query that returns the data…
2 replies
All, I have recently faced the below scenario. i.e to add comma as the thousand seperator I have se…
7 replies
hi there, many times there is the requirement of selecting multiple records into one xml-string. Us…
13 replies
Hello All, I'd like to specify a dynamic Top criteria and return the top number of records per grou…
4 replies
ProjectTable: ID ProjectID ProjectName 1 PRO14 Demo 2 PRO15 Tes…
2 replies
DECLARE @myDoc xml DECLARE @AppName VARCHAR(100) SET @myDoc = '<assembly xmlns="urn:schemas-micr…
3 replies
Hi Gurus, Is someone can help me with Table Partition? with e.g or show me tutorial that would be a…
2 replies
Hi - can't seem to get my head around this one, so any assistance is welcome. I am trying to write…
35 replies
I've a table like below: CREATE TABLE #Emp ( Emp char(6), UplineEmp char(6), Lvl tinyint) ; insert …
4 replies
Viewing 15 topics - 4,666 through 4,680 (of 10,647 total)
You must be logged in to create new topics.