I’m trying to buy a book for reference and learn SQL. I have Java background and a lot of people …
1 day, 8 hours ago
By: Grant Fritchey
I have a process that uses SqlAgent jobs to process data coming from many sources, and I'm seeing p…
1 week, 4 days ago
I am having one requirement where I want to show only first Friday of every month of 2014,2015 …
3 weeks, 4 days ago
By: Jonathan AC Roberts
Looking for some suggestions.
Currently, In our system we have GUIDs are primary keys and…
3 weeks, 5 days ago
By: Jeff Moden
i have a stored procedure which outputs data from various table query like below.
create procedure …
1 month ago
I have this query that gets every Friday of the year, I am trying to get the second Friday of every…
The above data NAZARE =Lastname , Dev=Firstname T= las…
1 month, 2 weeks ago
Okay, before someone asks, this is not homework... I just can't figure out how to do it. 🙂
there are LineNo, itemNo and qty fields in one table, I want to the accumulative qty (totalQty) for…
1 month, 3 weeks ago
I have a table with the field 'datestamp' stored in 'yyyy-mm-dd' format and this query is not worki…
2 months, 1 week ago
DECLARE @test VARCHAR
SET @test = '[Copy]-'
Select @test + 'SomeName'
I want ...
,DATENAME(dw, [myDateTime]) as DOW
group by DATEN…
2 months, 4 weeks ago
I want to create a Extended Event that logs all queries from a specific user or every user e…
3 months, 1 week ago
Can someone help me figure out how to turn this string:
By: Jeffrey Williams
I've been using OPENQUERY to select from a MySQL db via a linked server
and trying to use the f…
3 months, 2 weeks ago
By: Mr. Brian Gale
Viewing 15 topics - 1 through 15 (of 4,912 total)
You must be logged in to create new topics.