Topics
Started by
Posts
Last post
Hello Team, I have a store procedure which is used to insert the data into my main table. I my proc…
2 replies
For some reason this works fine running in SSMS, but it errors out in SRS. I tried seaching for th…
1 replies
Hi everyone, In the constant search for a "perfect" propercase function, I came across the followin…
4 replies
With out using UDF Suppose i have a string like TEST, then i just want to output string as TES. Nee…
6 replies
Hello all, I have been testing another propercase function: USE [MyDatabase] GO /****** Object: Us…
3 replies
Hi All, I have table which contain multiple records for one id e.g. a_ida_adda1_adda3_add a4_dt …
4 replies
If I have multiple xml schema's for one column call it "properties". Can i validate against all the…
1 replies
How can I obtain the only date part of a datetime field? Thanks for your help Viky
17 replies
I am working on a project where I have a table with several fields (involvedIIP1, engagedIPOA1, exp…
5 replies
Hi, I would like to know if it is possible to do a cross tab on data which typically cannot be aggr…
6 replies
Hello all. I need some help in optimizing query with aggregate function and case statement Here is …
3 replies
I have the following data. Number Name 1 xxx 1 yyy 2 xxx 2 zzz …
1 replies
All, Pls refer some good book names for SSIS & SSAS. The book should teach me from basic (ste…
1 replies
I have a stored procedure that executes based off a @startdate and @enddate parameters. I run this …
1 replies
Hi - I am running this code and am receiving the error: (28400 row(s) affected) Msg 536, Level 16, …
6 replies
Viewing 15 topics - 3,556 through 3,570 (of 12,234 total)
You must be logged in to create new topics.