Topics
Started by
Posts
Last post
Hi Hi I want to create a sql script which loops through a column (segment) and transforms the valu…
9 replies
Hi Everyone I have a merge statement which ends with the following WHEN NOT MATCHED BY SOURCE THE…
10 replies
I am not sure if I am doing something wrong, but I am getting an issue that seems to be part of the…
2 replies
Morning! I have a script which reindex's\reorgs index's depending on their fragmentation. But, it …
16 replies
I want to write a query to flatten the hierarchy of a table and I don't know what's best way to do…
1 replies
I have a table called T1 and column called C1.It contains one code like TCR-ABCDE12345. I have anot…
4 replies
Hi. I have created database mail profile account with SMTP also email realy working.. Could you hel…
13 replies
It doesn't look like Microsoft made it easy to pivot (like Matrix in SSRS) when the number of colum…
4 replies
Using T-SQL (SS2K8) in a stored procedure, I have created a temp table (#Month) with (Month, Year, …
4 replies
Hi, I have a issue where we got to report money column in string in the format 1,00,000.00 Example.…
7 replies
Hi friends, When I run the below procedure am getting as CPU utilization of the server is 185% ,300…
2 replies
From what I can find... it looks like working with strings is more of a headace .. in SQL than Pick…
5 replies
I need some assistance with a database size report. I have data pulled into a table that has a Repo…
3 replies
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'archer' and state = 0) BEGIN use arche…
11 replies
Hi all, I was creating a stored procedure but in this sp for some columns I need to call a function…
2 replies
Viewing 15 topics - 3,076 through 3,090 (of 10,647 total)
You must be logged in to create new topics.