Topics
Started by
Posts
Last post
Is it possible to have a subquery in a PIVOT statement? Reason I'm asking is the subquery returns t…
7 replies
I have a Stored Procedure that uses OPENROWSET to an Excel spreadsheet and sends the SELECT results…
1 replies
I would like to change definition of all views and want to replace all tables used in view definiti…
3 replies
I have a table with three fields, FirstName, LastName and EmailAddress. The EmailAddress field is a…
10 replies
Iām trying to buy a book for reference and learn SQL. I have Java background and a lot of people …
1 replies
I have a process that uses SqlAgent jobs to process data coming from many sources, and I'm seeing p…
56 replies
Hi, I am having one requirement where I want to show only first Friday of every month of 2014,2015 …
61 replies
Hi All, Looking for some suggestions. Currently, In our system we have GUIDs are primary keys and…
58 replies
i have a stored procedure which outputs data from various table query like below. create procedure …
2 replies
I have this query that gets every Friday of the year, I am trying to get the second Friday of every…
22 replies
NAZARE|DEV|T||Current~NAZARE|DEV|T||Previous The above data NAZARE =Lastname , Dev=Firstname T= las…
4 replies
Okay, before someone asks, this is not homework... I just can't figure out how to do it. š I hav…
9 replies
there are LineNo, itemNo and qty fields in one table, I want to the accumulative qty (totalQty) for…
11 replies
I have a table with the field 'datestamp' stored in 'yyyy-mm-dd' format and this query is not worki…
5 replies
Hi, DECLARE @test VARCHAR SET @test = '[Copy]-' Select @test + 'SomeName' I want ... [Copy]- SomeNa…
2 replies
Viewing 15 topics - 76 through 90 (of 4,982 total)
You must be logged in to create new topics.