Topics
Started by
Posts
Last post
Hello community! The following code has baffled me and my friend (he found this). Sample data is at…
3 replies
What are the advantage of using cross apply over union all?
9 replies
I have the following data DROP TABLE mytable; CREATE TABLE mytable( cst_org_name_dn VARCHAR…
5 replies
Hi, I want to group the following table but it must be grouped using a data range. Difficult to exp…
4 replies
My resultant table holds data as: Id A B C ValidFrom Val…
1 replies
Hi I need a script to recreate a list of tables stored in a table. The fields have to be in the sam…
21 replies
Our weeks run Saturday through Friday. The month the week falls in is determined by Saturday's date…
7 replies
Create table FinalResult (Id int, A int, B int, C int, D int, E int, Va…
1 replies
Hi Hope someone can help me out I have a table like the one Below TagIndex DateAndTime …
7 replies
Any ways to generate SQL logins with passwords ... Revlogin and other scripts will give the passwo…
2 replies
Hi there, Following code will do the job for me. But I wonder is there any other way to accomplish.…
5 replies
I have a snippet of T-SQL code that I use as a function. All it does is, take a string that has sev…
6 replies
Hi All, I am trying to setup a select query + where statement with parameters that KeyID equals num…
3 replies
We have several hundreds of tables in a database (OLTP system). Only few tables are being used by r…
1 replies
Hi There, I hope someone can help me resolve this issue. I am working on query which requires follo…
2 replies
Viewing 15 topics - 1,996 through 2,010 (of 4,984 total)
You must be logged in to create new topics.