Topics
Started by
Posts
Last post
I want to group the data by consecutive months (mydate). how can i do this? Data looks like this:…
6 replies
I have a linked server pointing to an Oracle instance using OraOLEDB.Oracle. The table contains a…
24 replies
I want to get the sum and I want to get the sum of only last month for VenNum by FiYr and DocDte. …
3 replies
insert into NewKms8081..members SELECT (select u2.Id from SecurityKms8081..users u2 join S…
2 replies
Not sure I have this 2nd left join correct. I need to grab the closest #Deptvalues.DeptDate and #De…
3 replies
Hello everyone, I hope you can help me. I have a table with measurement data. Each measurement has …
2 replies
Given the following table and query, this will return any records(based on message_id) that have ti…
2 replies
Sample query reply appreciated Getting the following error: Conversion failed when converting the v…
5 replies
Hello everyone, I need your help. I have a “datetime” column (data type is Varchar(64) )with th…
5 replies
Hello, I'm trying to remove results from this sql statement where the custid like '%abc%' and compa…
12 replies
By: itemD2R
Hi there, I've tried CROSS APPLY, PATINDEX and many other functions, but can't nail this. For each …
13 replies
Sorry, more bakery stuff. Say I buy ingredients over time and I want to know how the total ingredie…
5 replies
Hello , Consider the following - much simplified - example of a conditional insert: insert into s…
3 replies
By: blom0344
Sorry for the lame title... I'm working on the same bakery problem as before. Manufacture--(M,1)--P…
5 replies
How do I use a variable name for a linked server name in a linked server query? set @servername = (…
1 replies
Viewing 15 topics - 16 through 30 (of 316 total)
You must be logged in to create new topics.