Topics
Started by
Posts
Last post
I have Table1.ColA that contains a Varchar(50) sting that I need to fuzzy-lookup against Tabl…
2 replies
Hi, CREATE TABLE Activations( ID INT ,ActivityName VARCHAR(20) ,UserID INT ) INSERT INTO Activati…
1 replies
I would like a query to update Table:DutyA Action column with word "create"if when joined to Table:…
1 replies
I have a table with about 12M records. Between the columns, there is a datetime field D and a bit f…
4 replies
This is my 4th day on SQL so I am a newbie. I created a query to import from an xml file. It works …
127 replies
If I have a query on a table that has a primary key and a description column and I am grouping by t…
3 replies
Hello, I'm hoping to get some ideas/links of the best way to accomplish the below requirement. I h…
3 replies
Is there an elegant solution to count(*) zero if there are no rows in the 'second' table. SELECT CO…
2 replies
I would like to use PIVOT for converting multiple rows into multiple columns. Here is the current …
3 replies
Hello. I am having a difficult time with SSIS versions. I am trying to fix an dtsx pack…
1 replies
Remarks: It was a problem with default settings in options in SSMS which prevented LF/CR not to be …
2 replies
TableOfData has 50 some columns. I want to grab 20 rows (doesn't matter which ones) for certain val…
7 replies
Hi, I have this data below; CREATE TABLE UserTable( &…
2 replies
Hello community, I am writing a query to calculate the nr. of pairs that ca…
1 replies
I've been searching around the Internet and have not found anything for this, therefore it is possi…
9 replies
Viewing 15 topics - 1,651 through 1,665 (of 3,091 total)
You must be logged in to create new topics.